Database software, including DBMS configuration files, must be stored in dedicated directories, separate from the host OS and other applications.

Overview

Finding ID	Version	Rule ID	IA Controls	Severity
V-79169	SQL6-D0-006800	SV-93875r1_rule		Medium

Description
When dealing with change control issues, it should be noted any changes to the hardware, software, and/or firmware components of the information system and/or application can potentially have significant effects on the overall security of the system. Multiple applications can provide a cumulative negative effect. A vulnerability and subsequent exploit to one application can lead to an exploit of other applications sharing the same security context. For example, an exploit to a web server process that leads to unauthorized administrative access to host system directories can most likely lead to a compromise of all applications hosted by the same system. Database software not installed using dedicated directories both threatens and is threatened by other hosted applications. Access controls defined for one application may by default provide access to the other application's database objects or directories. Any method that provides any level of separation of security context assists in the protection between applications.

Description

When dealing with change control issues, it should be noted any changes to the hardware, software, and/or firmware components of the information system and/or application can potentially have significant effects on the overall security of the system. Multiple applications can provide a cumulative negative effect. A vulnerability and subsequent exploit to one application can lead to an exploit of other applications sharing the same security context. For example, an exploit to a web server process that leads to unauthorized administrative access to host system directories can most likely lead to a compromise of all applications hosted by the same system. Database software not installed using dedicated directories both threatens and is threatened by other hosted applications. Access controls defined for one application may by default provide access to the other application's database objects or directories. Any method that provides any level of separation of security context assists in the protection between applications.

STIG	Date
MS SQL Server 2016 Instance Security Technical Implementation Guide	2018-03-09

Details

Check Text ( C-78761r1_chk )
Determine the directory in which SQL Server has been installed. Using SQL Server Management Studio's Object Explorer: Right-click [SQL Server Instance] >> Facets >> Record value for RootDirectory. Verify that this path does not exist on the same drive as the Operating System. Using Windows Explorer, navigate through all parts of this path verifying that no evidence exists of non-SQL Server or administrative files being stored in the same location. If any non-SQL Server or administrative files are being stored in this location, this is a finding.

Check Text ( C-78761r1_chk )

Determine the directory in which SQL Server has been installed.

Using SQL Server Management Studio's Object Explorer:

Right-click [SQL Server Instance] >> Facets >> Record value for RootDirectory.

Verify that this path does not exist on the same drive as the Operating System.

Using Windows Explorer, navigate through all parts of this path verifying that no evidence exists of non-SQL Server or administrative files being stored in the same location.

If any non-SQL Server or administrative files are being stored in this location, this is a finding.

Fix Text (F-85921r1_fix)
Re-install SQL Server application components using dedicated directories that are separate from the operating system. Relocate or reinstall other application software that currently shares directories with SQL Server components. Separate from the operating system and/or temporary storage.